--create new database
--filename should be the path of the dropbox project folder so that we all can use the same database
create database bankingdb 
on (name = bankingdbmdf, filename = 'C:\Users\Sync\Dropbox\semester 2 assignments\EC2\Project\Database\Scotiadb.mdf', size = 1MB, maxsize= unlimited, filegrowth = 1MB) 
log on (name = bankingdbldf, filename = 'C:\Users\Sync\Dropbox\semester 2 assignments\EC2\Project\Database\Scotiadb.ldf', size = 1MB, maxsize = unlimited, filegrowth = 1MB);
go

--attach attach database
--filename should be the path of the dropbox project folder so that we all can use the same database
create database bankingdb
on (filename = '\C:\Users\Sync\Dropbox\semester 2 assignments\EC2\Project\Database\bankingdb.mdf')
for attach;
go

